/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50542
 Source Host           : localhost:3306
 Source Schema         : 1808yysh

 Target Server Type    : MySQL
 Target Server Version : 50542
 File Encoding         : 65001

 Date: 02/11/2018 16:57:24
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for yysh_access_log
-- ----------------------------
DROP TABLE IF EXISTS `yysh_access_log`;
CREATE TABLE `yysh_access_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg` varchar(255) DEFAULT NULL COMMENT '操作信息',
  `to_user` int(11) DEFAULT NULL COMMENT '给哪个用户的',
  `type` tinyint(4) DEFAULT NULL COMMENT '类型：1.推荐奖',
  `addtime` int(11) DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yysh_access_log
-- ----------------------------
BEGIN;
INSERT INTO `yysh_access_log` VALUES (1, '成功推荐zhangsansan;获得一级推荐奖励30', 14, 1, 1541142723);
INSERT INTO `yysh_access_log` VALUES (2, '成功推荐zhangsansan;获得二级推荐奖励20', 11, 1, 1541142724);
INSERT INTO `yysh_access_log` VALUES (3, '成功推荐zhangsansan;获得三级推荐奖励10', 9, 1, 1541142724);
COMMIT;

-- ----------------------------
-- Table structure for yysh_ad
-- ----------------------------
DROP TABLE IF EXISTS `yysh_ad`;
CREATE TABLE `yysh_ad` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `src` varchar(255) DEFAULT NULL,
  `ord` int(11) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yysh_ad
-- ----------------------------
BEGIN;
INSERT INTO `yysh_ad` VALUES (16, '20181029/004ee8fe8e5019f4d73205c7839942f4.jpeg', 1, 'http://ad.funshion.org.cn/u/index2.html?s=30108&w=300&h=250&pvid=0001479435158058_1493354861');
INSERT INTO `yysh_ad` VALUES (17, '20181029/a6582a1edc792a1ca6df2d4c23b67628.jpeg', 2, 'http://ad.funshion.org.cn/u/index2.html?s=30108&w=300&h=250&pvid=0001479435158058_1493354861');
INSERT INTO `yysh_ad` VALUES (18, '20181029/1c27ec1263288a151c0ba1ba397f9cfc.jpeg', 3, 'http://ad.funshion.org.cn/u/index2.html?s=30108&w=300&h=250&pvid=0001479435158058_1493354861');
INSERT INTO `yysh_ad` VALUES (19, '20181029/2ce9287f3e6bae576d94dc9c04e3e4f3.jpeg', 5, 'http://ad.funshion.org.cn/u/index2.html?s=30108&w=300&h=250&pvid=0001480402692315_173984016');
INSERT INTO `yysh_ad` VALUES (20, '20181029/20c7cd30c48ce117ccf9f50879d38e20.jpeg', 7, 'http://ad.funshion.org.cn/u/index2.html?s=30108&w=300&h=250&pvid=0001480402692315_173984016');
INSERT INTO `yysh_ad` VALUES (21, '20181029/04db1d979ad0b19382cdaac349582dbc.jpeg', 11, 'http://ad.funshion.org.cn/u/index2.html?s=30108&w=300&h=250&pvid=0001480402692315_173984016');
INSERT INTO `yysh_ad` VALUES (25, '20181030/77164e01b987cb6c29da7cece2552915.jpeg', 12, '21345678');
INSERT INTO `yysh_ad` VALUES (26, '20181030/aa8612046f8e06ace962d5a9acd0eaa6.jpeg', 11, '21345678');
COMMIT;

-- ----------------------------
-- Table structure for yysh_admin
-- ----------------------------
DROP TABLE IF EXISTS `yysh_admin`;
CREATE TABLE `yysh_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `pwd` char(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yysh_admin
-- ----------------------------
BEGIN;
INSERT INTO `yysh_admin` VALUES (1, 'tom', 'e10adc3949ba59abbe56e057f20f883e');
COMMIT;

-- ----------------------------
-- Table structure for yysh_config
-- ----------------------------
DROP TABLE IF EXISTS `yysh_config`;
CREATE TABLE `yysh_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yysh_config
-- ----------------------------
BEGIN;
INSERT INTO `yysh_config` VALUES (1, '一级推荐奖励', '30');
INSERT INTO `yysh_config` VALUES (2, '二级推荐奖励', '20');
INSERT INTO `yysh_config` VALUES (3, '三级推荐奖励', '10');
COMMIT;

-- ----------------------------
-- Table structure for yysh_member
-- ----------------------------
DROP TABLE IF EXISTS `yysh_member`;
CREATE TABLE `yysh_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `nickname` varchar(255) DEFAULT NULL,
  `password` char(32) DEFAULT NULL,
  `money` decimal(10,2) DEFAULT '0.00' COMMENT '余额',
  `point` int(11) DEFAULT '0' COMMENT '积分',
  `weibo_id` varchar(255) DEFAULT NULL,
  `header_img` varchar(255) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL COMMENT '推荐人id',
  `mail` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yysh_member
-- ----------------------------
BEGIN;
INSERT INTO `yysh_member` VALUES (9, 'zhangsan', '张三', 'e10adc3949ba59abbe56e057f20f883e', 99999999.99, 20, NULL, NULL, 0, NULL, NULL);
INSERT INTO `yysh_member` VALUES (10, 'lisi', '李四', 'e10adc3949ba59abbe56e057f20f883e', 99999999.99, 0, NULL, NULL, 9, NULL, NULL);
INSERT INTO `yysh_member` VALUES (11, 'wangwu', '王五', 'e10adc3949ba59abbe56e057f20f883e', 20.50, 40, NULL, NULL, 9, NULL, NULL);
INSERT INTO `yysh_member` VALUES (12, 'zhaoliu', '赵六', 'e10adc3949ba59abbe56e057f20f883e', 20.12, 0, NULL, NULL, 10, NULL, NULL);
INSERT INTO `yysh_member` VALUES (13, 'dengqi', '邓七', 'e10adc3949ba59abbe56e057f20f883e', 99999999.99, 0, NULL, NULL, 11, NULL, NULL);
INSERT INTO `yysh_member` VALUES (14, 'wangba', '王八', 'e10adc3949ba59abbe56e057f20f883e', 0.00, 60, NULL, NULL, 11, NULL, NULL);
INSERT INTO `yysh_member` VALUES (15, 'laojiu', '老九', 'e10adc3949ba59abbe56e057f20f883e', 0.00, 0, NULL, NULL, 12, NULL, NULL);
INSERT INTO `yysh_member` VALUES (16, 'zhangsansan', '张三三', 'e10adc3949ba59abbe56e057f20f883e', 0.00, 0, NULL, NULL, 14, NULL, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
